{"id":1455,"date":"2023-11-14T12:42:18","date_gmt":"2023-11-14T12:42:18","guid":{"rendered":"https:\/\/www.devopsfreelancer.com\/blog\/?p=1455"},"modified":"2023-11-14T12:43:02","modified_gmt":"2023-11-14T12:43:02","slug":"list-of-mysql-query-performance-in-laravel","status":"publish","type":"post","link":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/","title":{"rendered":"List of MySQL Query Performance in Laravel ?"},"content":{"rendered":"\n

In this tutorial we’re going to learn what are the steps for impoving the MySQL Query performance in Laravel.<\/p>\n\n\n\n

1. What is Chunk function ?<\/strong><\/h2>\n\n\n\n

The chunk<\/code> method in Laravel is primarily designed to help with memory efficiency rather than directly improving MySQL query performance. It allows you to process large result sets in smaller \u201cchunks\u201d to avoid loading the entire dataset into memory at once. This can be beneficial when dealing with large datasets to prevent memory exhaustion.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Perfomance of using Chunk function ?<\/strong><\/h2>\n\n\n\n
    \n
  1. Memory Efficiency:<\/strong> When retrieving a large result set, fetching all records at once can consume a significant amount of memory. By using chunk<\/code>, you process and handle a subset of records at a time, reducing the overall memory footprint.<\/li>\n\n\n\n
  2. Avoiding Timeout Issues:<\/strong> For long-running processes, especially in environments with script execution time limits, using chunk<\/code> can help avoid script timeout issues. It ensures that the process is executed in smaller increments, preventing timeouts.<\/li>\n<\/ol>\n\n\n\n

    While chunk<\/code> itself doesn\u2019t directly optimize the underlying MySQL query, it indirectly contributes to better performance by addressing memory-related challenges. If you\u2019re looking to optimize MySQL queries, you might want to focus on other aspects like proper indexing, query structure, and database design.<\/p>\n\n\n\n

    Example of Chunk function<\/strong><\/p>\n\n\n\n

    public function get_organisation()\n    {\n         $getting_organisation = [];\n\n        Organisation::latest()->chunkById(200, function ($organisations) use (&$getting_organisation) {\n            foreach ($organisations as $organisation) {\n                $getting_organisation[] = $organisation;\n            }\n        }, 'id');\n\n        Log::info('coming all organisation in organisation page', ['data_count' => count($getting_organisation)]);\n        return view('organization-page', compact('getting_organisation'));\n    });<\/code><\/pre>\n\n\n\n
    Output:-<\/strong><\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    Now open network and check the response timing.<\/strong><\/p>\n\n\n\n
    Before of using Chunk function<\/strong><\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    After using of chunk function its reducing too much timing.<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    2. Use pluck Function <\/strong><\/h2>\n\n\n\n
    What is Pluck Function ?<\/strong><\/h2>\n\n\n\n
    The pluck()<\/code> method in Laravel is a useful tool for retrieving specific values from a collection of data. It allows you to extract a single key from each item in the collection and return an array of those values. This can be particularly helpful when you only need to work with a subset of the data, or when you want to create a new array based on specific criteria.<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    Perfomance of using Pluck function in Laravel ?<\/strong><\/h2>\n\n\n\n
      \n
    1. Reduced Data Transfer:<\/strong> pluck<\/code> retrieves only the specified column(s) from the database, reducing the amount of data transferred between the database and your application. This is particularly useful when dealing with large datasets.<\/li>\n\n\n\n
    2. Less Memory Usage:<\/strong> Since pluck<\/code> only retrieves a single column from each row, it consumes less memory compared to fetching entire rows of data. This can be beneficial when working with limited memory resources.<\/li>\n\n\n\n
    3. Faster Processing:<\/strong> Smaller result sets, obtained through pluck<\/code>, can lead to faster processing times, especially when you don’t need all the columns of each row. This can improve the overall speed of your application.<\/li>\n\n\n\n
    4. Optimized Queries:<\/strong> The generated SQL queries by pluck<\/code> are optimized for fetching specific columns, and they are often more efficient than queries fetching all columns.<\/li>\n<\/ol>\n\n\n\n
      Example :- <\/strong><\/h2>\n\n\n\n
      public function get_organisation()\n{\n    $org_names = Organisation::latest()->pluck('org_name');\n\n    Log::info('coming all organisation in organisation page', ['data_count' => count($org_names)]);\n\n    return view('organization-page', compact('org_names'));\n}<\/code><\/pre>\n\n\n\n
      3. Better way to retrieve latest rows from a table<\/strong><\/h2>\n\n\n\n
      To retrieve the latest rows from a table in Laravel, you can use the latest<\/code> method combined with get<\/code> or other query builder methods. Here are a couple of examples:<\/p>\n\n\n\n
      The latest()<\/code> scope provided by Laravel allows you to easily order the results by the specified column in descending order. To retrieve the latest row from a table, you can use the following syntax:<\/p>\n\n\n\n
      Example :- <\/strong><\/p>\n\n\n\n
      public function getLatestRecord()\n{\n    $latests = User::latest()->get();\n\n    dd($latests);\n}<\/code><\/pre>\n\n\n\n
      Example :- <\/p>\n\n\n\n
      Output\n\narray:4 [\n\n  0 => array:3 [\n\n    \"name\" => \"keval\"\n\n    \"email\" => \"keval@gmail.com\"\n\n    \"created_at\" => \"2019-12-26 00:00:00\"\n\n  ]\n\n  1 => array:3 [\n\n    \"name\" => \"piyush\"\n\n    \"email\" => \"piyush@gmail.com\"\n\n    \"created_at\" => \"2019-12-25 00:00:00\"\n\n  ]\n\n  2 => array:3 [\n\n    \"name\" => \"savan\"\n\n    \"email\" => \"sava@gmail.com\"\n\n    \"created_at\" => \"2019-12-09 00:00:00\"\n\n  ]\n\n  3 => array:3 [\n\n    \"name\" => \"mehul\"\n\n    \"email\" => \"mehul@gmail.com\"\n\n    \"created_at\" => \"2019-12-01 00:00:00\"\n\n  ]\n\n]\n\n<\/code><\/pre>\n\n\n\n
      4. Table Indexing<\/strong><\/h2>\n\n\n\n
      Table indexing in Laravel is an essential aspect of database optimization. Indexing helps speed up query execution by providing a faster way to look up data. Laravel allows you to define indexes using migrations. Indexes are used to quickly retrieve data without having to search every row in a table every time a database table is accessed. Small database wont be noticed but once it grows, the query getting time consuming.<\/p>\n\n\n\n
      Without index, the process will be from top to bottom of the user data until it the email<\/code> is found. Here is some comparison between with index and without it.<\/p>\n\n\n\n
      Without index<\/strong> \u2014 750ms<\/code><\/pre>\n\n\n\n
      With index<\/strong> \u2014 2ms (400x faster)<\/code><\/pre>\n\n\n\n
      In Laravel, the easy way is create a migration file to alter your desire table<\/p>\n\n\n\n
      Example :-<\/strong><\/h2>\n\n\n\n
       public function up()\n    {\n        Schema::create('example', function (Blueprint $table) {\n            $table->id();\n            $table->string('name')->unique();\n            $table->integer('age');\n            $table->index(['name', 'age']);\n            $table->timestamps();\n        });\n    }<\/code><\/pre>\n\n\n\n
      Now migrate the table<\/p>\n\n\n\n
      php artisan migrate<\/code><\/pre>\n\n\n\n
      By creating this migration, we can speed up our table. Keep in mind, however, this index will only be applied if we search the product using the whole title or the start of the title. <\/p>\n\n\n\n
      5. Select only the columns you need<\/strong><\/h2>\n\n\n\n
      Selecting only the columns you need in Laravel is a good practice for optimizing performance and reducing unnecessary data transfer. You can use the select<\/code> method on the query builder to specify the columns you want to retrieve.<\/p>\n\n\n\n
      Example :- <\/p>\n\n\n\n
       $getting_value = DB::table('Organisation')->select('org_name')->get();<\/code><\/pre>\n\n\n\n
      Replace 'your_table'<\/code> with the actual name of your table and list the columns you need in the select<\/code> method. <\/p>\n\n\n\n
      This way, only the specified columns will be retrieved from the database, improving performance and reducing the amount of data transferred.<\/p>\n\n\n\n
      Thanks for learning.<\/p>\n","protected":false},"excerpt":{"rendered":"
      In this tutorial we’re going to learn what are the steps for impoving the MySQL Query performance in Laravel. 1. What is Chunk function ? The chunk method in… <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[550],"tags":[510,278,88,571,572],"class_list":["post-1455","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-laravel-performance","tag-laravel-query","tag-mysql","tag-mysql-performance","tag-php-mysql"],"yoast_head":"\nList of MySQL Query Performance in Laravel ? - DevOps Freelancer<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"List of MySQL Query Performance in Laravel ? - DevOps Freelancer\" \/>\n<meta property=\"og:description\" content=\"In this tutorial we’re going to learn what are the steps for impoving the MySQL Query performance in Laravel. 1. What is Chunk function ? The chunk method in...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/\" \/>\n<meta property=\"og:site_name\" content=\"DevOps Freelancer\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/amitsthakurs\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-14T12:42:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-14T12:43:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.devopsfreelancer.com\/blog\/wp-content\/uploads\/2023\/11\/image-36.png\" \/>\n<meta name=\"author\" content=\"Amit Kumar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/amits_thakurs\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Amit Kumar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/list-of-mysql-query-performance-in-laravel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/list-of-mysql-query-performance-in-laravel\\\/\"},\"author\":{\"name\":\"Amit Kumar\",\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/#\\\/schema\\\/person\\\/22ed4bd82dc04200a2ca541b3e35fc5b\"},\"headline\":\"List of MySQL Query Performance in Laravel ?\",\"datePublished\":\"2023-11-14T12:42:18+00:00\",\"dateModified\":\"2023-11-14T12:43:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/list-of-mysql-query-performance-in-laravel\\\/\"},\"wordCount\":771,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/list-of-mysql-query-performance-in-laravel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/image-36.png\",\"keywords\":[\"laravel-performance\",\"laravel-query\",\"mysql\",\"mysql-performance\",\"php-mysql\"],\"articleSection\":[\"MysQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/list-of-mysql-query-performance-in-laravel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/list-of-mysql-query-performance-in-laravel\\\/\",\"url\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/list-of-mysql-query-performance-in-laravel\\\/\",\"name\":\"List of MySQL Query Performance in Laravel ? - DevOps Freelancer\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/list-of-mysql-query-performance-in-laravel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/list-of-mysql-query-performance-in-laravel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/image-36.png\",\"datePublished\":\"2023-11-14T12:42:18+00:00\",\"dateModified\":\"2023-11-14T12:43:02+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/#\\\/schema\\\/person\\\/22ed4bd82dc04200a2ca541b3e35fc5b\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/list-of-mysql-query-performance-in-laravel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/list-of-mysql-query-performance-in-laravel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/list-of-mysql-query-performance-in-laravel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/image-36.png\",\"contentUrl\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/image-36.png\",\"width\":993,\"height\":597},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/list-of-mysql-query-performance-in-laravel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"List of MySQL Query Performance in Laravel ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/\",\"name\":\"DevOps Freelancer\",\"description\":\"We provide DevOps | SRE | DevSecOps | MLOps Freelancing\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/#\\\/schema\\\/person\\\/22ed4bd82dc04200a2ca541b3e35fc5b\",\"name\":\"Amit Kumar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d76fb4d0f15f7a458f1fd91063b44fbb7e7eb9e724b1c465d885054c2540250f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d76fb4d0f15f7a458f1fd91063b44fbb7e7eb9e724b1c465d885054c2540250f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d76fb4d0f15f7a458f1fd91063b44fbb7e7eb9e724b1c465d885054c2540250f?s=96&d=mm&r=g\",\"caption\":\"Amit Kumar\"},\"description\":\"Hi I am Amit Kumar Thakur Experienced as s Software Developer with a demonstrated history of working in the information technology and services industry. Skilled in HTML, CSS, Bootstrap4, PHP, Laravel-9 , REST API,FB API,Google API, Youtube Api, Bitbucket,Github,Linux and jQuery. Strong engineering professional focused in Computer\\\/Information Technology Administration and Management. Currently my profile is to Software Developer, analyze the requirement, creating frame for web application, coding and maintenance.\",\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/amitsthakurs\\\/\",\"https:\\\/\\\/www.instagram.com\\\/amits_thakurs\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/amits-thakurs\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/amits_thakurs\"],\"url\":\"https:\\\/\\\/www.devopsfreelancer.com\\\/blog\\\/author\\\/amit\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"List of MySQL Query Performance in Laravel ? - DevOps Freelancer","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/","og_locale":"en_US","og_type":"article","og_title":"List of MySQL Query Performance in Laravel ? - DevOps Freelancer","og_description":"In this tutorial we’re going to learn what are the steps for impoving the MySQL Query performance in Laravel. 1. What is Chunk function ? The chunk method in...","og_url":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/","og_site_name":"DevOps Freelancer","article_author":"https:\/\/www.facebook.com\/amitsthakurs\/","article_published_time":"2023-11-14T12:42:18+00:00","article_modified_time":"2023-11-14T12:43:02+00:00","og_image":[{"url":"https:\/\/www.devopsfreelancer.com\/blog\/wp-content\/uploads\/2023\/11\/image-36.png","type":"","width":"","height":""}],"author":"Amit Kumar","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/amits_thakurs","twitter_misc":{"Written by":"Amit Kumar","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/#article","isPartOf":{"@id":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/"},"author":{"name":"Amit Kumar","@id":"https:\/\/www.devopsfreelancer.com\/blog\/#\/schema\/person\/22ed4bd82dc04200a2ca541b3e35fc5b"},"headline":"List of MySQL Query Performance in Laravel ?","datePublished":"2023-11-14T12:42:18+00:00","dateModified":"2023-11-14T12:43:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/"},"wordCount":771,"commentCount":1,"image":{"@id":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.devopsfreelancer.com\/blog\/wp-content\/uploads\/2023\/11\/image-36.png","keywords":["laravel-performance","laravel-query","mysql","mysql-performance","php-mysql"],"articleSection":["MysQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/","url":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/","name":"List of MySQL Query Performance in Laravel ? - DevOps Freelancer","isPartOf":{"@id":"https:\/\/www.devopsfreelancer.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/#primaryimage"},"image":{"@id":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.devopsfreelancer.com\/blog\/wp-content\/uploads\/2023\/11\/image-36.png","datePublished":"2023-11-14T12:42:18+00:00","dateModified":"2023-11-14T12:43:02+00:00","author":{"@id":"https:\/\/www.devopsfreelancer.com\/blog\/#\/schema\/person\/22ed4bd82dc04200a2ca541b3e35fc5b"},"breadcrumb":{"@id":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/#primaryimage","url":"https:\/\/www.devopsfreelancer.com\/blog\/wp-content\/uploads\/2023\/11\/image-36.png","contentUrl":"https:\/\/www.devopsfreelancer.com\/blog\/wp-content\/uploads\/2023\/11\/image-36.png","width":993,"height":597},{"@type":"BreadcrumbList","@id":"https:\/\/www.devopsfreelancer.com\/blog\/list-of-mysql-query-performance-in-laravel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.devopsfreelancer.com\/blog\/"},{"@type":"ListItem","position":2,"name":"List of MySQL Query Performance in Laravel ?"}]},{"@type":"WebSite","@id":"https:\/\/www.devopsfreelancer.com\/blog\/#website","url":"https:\/\/www.devopsfreelancer.com\/blog\/","name":"DevOps Freelancer","description":"We provide DevOps | SRE | DevSecOps | MLOps Freelancing","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.devopsfreelancer.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.devopsfreelancer.com\/blog\/#\/schema\/person\/22ed4bd82dc04200a2ca541b3e35fc5b","name":"Amit Kumar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d76fb4d0f15f7a458f1fd91063b44fbb7e7eb9e724b1c465d885054c2540250f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d76fb4d0f15f7a458f1fd91063b44fbb7e7eb9e724b1c465d885054c2540250f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d76fb4d0f15f7a458f1fd91063b44fbb7e7eb9e724b1c465d885054c2540250f?s=96&d=mm&r=g","caption":"Amit Kumar"},"description":"Hi I am Amit Kumar Thakur Experienced as s Software Developer with a demonstrated history of working in the information technology and services industry. Skilled in HTML, CSS, Bootstrap4, PHP, Laravel-9 , REST API,FB API,Google API, Youtube Api, Bitbucket,Github,Linux and jQuery. Strong engineering professional focused in Computer\/Information Technology Administration and Management. Currently my profile is to Software Developer, analyze the requirement, creating frame for web application, coding and maintenance.","sameAs":["https:\/\/www.facebook.com\/amitsthakurs\/","https:\/\/www.instagram.com\/amits_thakurs\/","https:\/\/www.linkedin.com\/in\/amits-thakurs\/","https:\/\/x.com\/https:\/\/twitter.com\/amits_thakurs"],"url":"https:\/\/www.devopsfreelancer.com\/blog\/author\/amit\/"}]}},"_links":{"self":[{"href":"https:\/\/www.devopsfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/1455","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsfreelancer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsfreelancer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsfreelancer.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsfreelancer.com\/blog\/wp-json\/wp\/v2\/comments?post=1455"}],"version-history":[{"count":2,"href":"https:\/\/www.devopsfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/1455\/revisions"}],"predecessor-version":[{"id":1462,"href":"https:\/\/www.devopsfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/1455\/revisions\/1462"}],"wp:attachment":[{"href":"https:\/\/www.devopsfreelancer.com\/blog\/wp-json\/wp\/v2\/media?parent=1455"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsfreelancer.com\/blog\/wp-json\/wp\/v2\/categories?post=1455"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsfreelancer.com\/blog\/wp-json\/wp\/v2\/tags?post=1455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}