SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974793 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974793 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423341,664199,593762,478784,343691,14957,782923,379932,127631,765660,943412,924432,478290,43207,596731,154077,185683,332822,653713,128500,586756,906927,377574,781833,1012904,364525,1020829,1005069,1021316,433708,726936,595178,990480,427314,484619,180823,289744,676996,312758,429250,790079,722159,481073,210677,1032775,281854,391646,879713,171308,1042814,255291,131113,321939,583017,501930,544673,548955,696165,700159,1015938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]