SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200414 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200414 [ RunTime:0.003127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336185,362763,883570,857961,927831,595266,771994,821874,374501,767802,837656,204443,458144,775264,76410,244632,937968,106660,813386,1045895,313070,623448,1042822,478501,14360,536477,583688,447999,139128,264146,653138,593044,742038,204697,823212,729682,862748,570063,234279,631507,878671,449602,207166,1036038,185356,259392,700189,163810,12485,780070,608681,49120,98475,903610,106205,594929,539016,863043,541258,305332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]