SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 370716 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 370716 [ RunTime:0.002882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439810,678531,826132,148914,1012016,307040,592084,85922,671429,799698,898643,472634,565765,272948,745357,472779,892205,66095,2360,269530,879674,403630,560480,973510,151226,768489,305507,194699,501636,262546,662521,388496,287464,633948,589161,197247,278665,274880,455050,67232,915895,515249,881483,556301,223034,684376,840774,314924,1031583,454140,614432,225348,627495,461350,132080,732826,1001483,31274,568666,279066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 370716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 370716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]