SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416336 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416336 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (760652,251106,963563,78486,34010,376285,136294,191565,56880,232674,306134,367497,236690,908464,578608,778893,602739,627568,688954,1020629,1032438,394184,793366,337426,856848,47991,31767,596035,893524,347431,331485,608549,968717,970098,774239,792636,332652,1037384,298426,1038069,240327,30312,743724,688647,836784,931715,1017207,748457,563779,95697,1017448,446782,372389,739791,686190,990572,340400,504326,328836,601499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]