SELECT 
  *, 
  cscart_product_tabs.status as status, 
  cscart_product_tabs.block_id as block_id, 
  cscart_product_tabs.company_id as company_id, 
  cscart_product_tabs_descriptions.name as name 
FROM 
  cscart_product_tabs 
  LEFT JOIN cscart_product_tabs_descriptions ON cscart_product_tabs.tab_id = cscart_product_tabs_descriptions.tab_id 
  LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_product_tabs.block_id 
WHERE 
  cscart_product_tabs_descriptions.lang_code = 'fr' 
  AND cscart_product_tabs.company_id = 3 
ORDER BY 
  position

Query time 0.00104

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_tabs ALL PRIMARY 75 Using where; Using filesort
1 SIMPLE cscart_product_tabs_descriptions eq_ref PRIMARY PRIMARY 9 mahm3t_cs443.cscart_product_tabs.tab_id,const 1 Using index condition
1 SIMPLE cscart_bm_blocks eq_ref PRIMARY PRIMARY 4 mahm3t_cs443.cscart_product_tabs.block_id 1 Using where

Result

tab_id tab_type block_id template addon position status is_primary product_ids company_id show_in_popup lang_code name type properties fpc_exclude_cache
111 T 0 blocks/product_tabs/description.tpl 0 A Y 3 N fr Description
120 B 540 1 D N 500,501,502,503,508,509,510 3 N fr Couleurs html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
144 B 696 2 D N 511,9513,10111,10160,10114,10115,10116,10192,10502 3 N fr SAH-Couleurs html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
112 T 0 blocks/product_tabs/features.tpl 3 A Y 3 N fr Caractéristiques
113 T 0 blocks/product_tabs/files.tpl 4 A Y 3 N fr Fichiers
33 T 0 blocks/product_tabs/description.tpl 5 D Y 3 N fr Description
34 T 0 blocks/product_tabs/features.tpl 6 D Y 3 N fr Caractéristiques
150 B 699 7 A N 11485,11488,414,426,430,431,434,435,436,437,438,439,443,504,527,617,651,717,750,1805,1806,3322,8281,8286,8303,8312,8313,8314,8352,8371,8665,9457,9463,9470,9818,9843,9845,9853,9865,9880,9938,10071,10157,10161,10195,10670,10699,10705,10960,428,429,478,480,514,533,598,659,1186,1804,3245,3315,3318,3320,3321,3323,3325,4939,7353,8275,8288,8289,8295,8300,8304,8306,8361,8364,8365,8367,8666,8721,8733,9842,9851,9882,9883,9885,9963,10065,10067,10070,10073,10101,10104,10221,10707,397,404,405,407,479,493,494,515,524,576,579,582,597,658,660,670,1187,3317,3319,8274,8277,8299,8305,8362,8369,8373,8720,8856,9848,9849,9868,9877,9935,9968,10063,10074,10103,10105,10167,10188,10201,10219,10353,387,389,402,406,516,526,706,1154,1648,1655,7351,8273,8285,8363,8370,8682,8686,9481,9482,9485,9819,9820,9838,9850,9864,9876,9892,9934,9943,10107,10152,10168,10177,10186,10191,10220,10222,10223,10355,10423,388,390,395,401,495,505,517,520,523,534,551,574,575,599,616,662,672,704,1645,3509,7352,8283,8287,8301,8735,9483,9513,9839,9855,9862,9863,9869,9875,9879,9900,9966,10148,10163,10428,393,398,497,535,563,566,572,657,669,721,1155,1189,1310,1311,3316,8284,8291,8368,8728,8729,8730,8731,8732,8734,9458,9484,9815,9817,9866,9878,9898,9939,9947,9965,10013,10066,10072,10095,10110,10145,10160,10162,10430,391,396,511,522,528,556,561,564,577,593,606,609,622,625,653,655,673,705,713,1157,1161,1166,1168,1777,4115,9825,9826,9854,9871,9874,9893,9897,9912,9913,9936,9940,9945,10012,10034,10068,10114,10124,10125,10147,10170,10218,10426,10434,446,499,559,560,565,578,580,600,603,638,654,674,675,710,718,719,720,1167,1644,3246,3520,3533,8272,8276,8347,8683,9510,9810,9840,9844,9861,9867,9881,9891,9894,9899,9916,9931,9937,9967,10033,10116,10143,10144,10146,10150,10153,10194,10413,10438,392,427,506,536,548,549,552,554,583,594,608,661,685,689,709,711,714,715,1159,1162,1171,1172,1181,1193,1196,1628,1787,2528,3324,9859,9944,9964,9970,9972,9991,10000,10023,10027,10037,10041,10096,10123,10149,10151,10159,10351,10440,10441,10444,10946,521,525,557,619,620,627,686,1156,1160,1178,1190,1197,2529,3527,3530,3531,3532,9467,9816,9841,9870,9873,9911,9946,9957,9969,9973,9974,9975,9977,10014,10016,10020,10022,10024,10029,10035,10038,10044,10047,10060,10106,10111,10154,10156,10169,10187,10225,10427,10967,394,501,507,529,567,601,707,716,1016,1174,1180,1640,1647,1801,3510,3521,3538,8350,8684,9480,9858,9941,9976,9978,9979,9982,9990,9997,10008,10019,10025,10026,10028,10036,10049,10051,10052,10057,10059,10061,10062,10164,10171,10175,10182,10419,10653,10702,399,423,553,555,558,604,605,623,624,642,656,1017,1163,1182,1183,1638,3507,3524,3528,8290,8349,8685,9476,9872,9890,9933,9949,9987,9992,9995,9998,10003,10010,10011,10021,10031,10048,10050,10053,10054,10056,10058,10117,10120,10165,10224,10232,10459,10501,10711,400,421,432,530,584,585,592,602,626,629,630,632,640,644,646,1158,1646,1651,1799,1802,2142,3508,8677,9811,9852,9857,9887,9889,9901,9950,9955,9956,9985,10030,10040,10042,10043,10119,10121,10181,10183,10184,10384,10414,10483,10678,10961,10966,447,498,500,502,512,570,573,631,635,636,641,722,725,1184,1192,1639,1649,1796,1798,1803,3247,3250,7354,8376,9846,9960,9989,10032,10064,10081,10118,10137,10226,10350,10363,10364,10389,10425,10429,10435,10442,10461,10466,10701,10962,11200,11204,11211,420,452,571,581,639,1194,1650,1653,1654,1795,1797,1800,3248,3249,3506,9468,9888,9930,9994,10018,10039,10069,10115,10122,10176,10190,10193,10227,10373,10374,10382,10383,10385,10405,10417,10418,10420,10431,10445,10460,10462,10463,10464,10465,10480,10482,10502,11203,11210,11218,422,424,508,510,513,568,569,607,633,645,647,671,1641,1652,3326,8346,9466,9847,9914,9915,9948,9951,9953,9996,9999,10015,10017,10131,10132,10229,10231,10367,10368,10369,10371,10372,10375,10376,10377,10378,10379,10381,10386,10387,10388,10408,10432,10436,10649,11220,425,503,509,531,532,587,612,613,634,637,650,1185,1188,1191,1195,8302,8351,8719,9469,9942,9952,9954,10126,10127,10128,10129,10130,10133,10134,10135,10155,10166,10180,10228,10230,10233,10354,10439,11205,11206,11207,11208,11214,11216,11217,11219,11221,11222,11224,11225,737,8348,8366,9474,9475,9477,9506,9507,9508,9509,9511,9828,9830,9833,9836,9837,9860,9895,9896,9961,10046,10055,10136,10158,10185,10235,10370,10421,10422,10433,10437,10500,10652,10669,10677,10680,10712,10959,10965,11196,11199,11209,11223,11486,11487,9827,9829,9831,9832,9834,9835,9962,10192,10424,10446,10447,10448,10449,10450,10451,10452,10453,10454,10455,10456,10457,10458,10499,10700,11215,11482 3 N fr Vitrage html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
35 T 0 blocks/product_tabs/files.tpl 10 A Y 3 N fr Files
136 B 688 13 D N 3 N fr Visualiser html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
139 B 691 14 D N 675,677,678,679,680,681,683,685,686,689,690,693,695,696,697,1171,1172,1173,1174,1175,1176,1177,1178,2523,3521,3522,3523,3524,3525,3526,3527,3528,3529,3530,3531,3532,3533,3534,3535,3537,3538,9499,9500,9501,9502,9504,9505,9972,9973,9974,9975,9976,9977,9978,9979,9980,9981,9982,9983,9984,9985,9986,9987,9988,9989,9990,9991,9992,9993,9994,9995,9996,9997,9998,9999,10000,10001,10002,10003,10004,10005,10006,10007,10008,10009,10010,10365,10366,10367,10368,10369,10370,10371,10372,10373,10374,10375,10376,10377,10378,10380,10381,10382,10383,10385,10387,10388,10393,10394,10395,10396,10397,10398,10399,10400,10401,10402,10403,10404,10405,10406,10407,10408,10410,10411,10412,10415,10416,10417,10418,10463,10464,10465,10466,10467,10468,10469,10470,10471,10472,10473,10474,10475,10476,10477,10478,10479,10481,10696 3 N fr Visualiser html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
166 T 0 addons/1clue_product_inquiry/blocks/product_tabs/product_inquiry.tpl 1clue_product_inquiry 15 D Y 3 N fr Poser une question sur le produit
159 T 0 addons/attachments/blocks/product_tabs/attachments.tpl attachments 35 A Y 3 N fr Fichiers joints
162 T 0 addons/discussion/blocks/product_tabs/discussion.tpl discussion 38 A Y 3 N fr Commentaires
165 T 0 addons/sd_youtube/blocks/product_tabs/youtube_video.tpl sd_youtube 41 A Y 3 N fr YouTube video
173 T 0 addons/cp_size_charts/blocks/product_tabs/cp_size_charts.tpl cp_size_charts 45 A Y 3 N fr Size charts
178 T 0 addons/image_gallery/blocks/product_tabs/gallery_images.tpl image_gallery 50 A Y 3 N fr Gallery images
179 T 0 addons/image_gallery/blocks/product_tabs/image_gallery.tpl image_gallery 51 A Y 3 N fr Images gallery