SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001979s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346366 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346366 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967028,232803,258165,423644,990954,460765,427042,471365,283635,685203,572559,742965,10060,540336,773018,799694,264115,47341,930084,1029126,326578,135614,154627,436961,591458,102904,718528,135631,935455,583913,569817,41012,969367,956253,391114,79050,620778,447608,4769,453614,16848,144669,789076,17850,408105,780961,107103,599390,852395,385732,790093,539780,896204,508469,259215,323084,553694,51469,676711,882747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]