SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513947 LIMIT 1 [ RunTime:0.001295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513947 [ RunTime:0.002684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358537,606381,590995,567659,417770,206990,2601,329667,113107,625398,68224,137279,335154,143902,765974,106613,914595,250060,35967,518611,1024750,356690,988256,498462,602831,20308,209987,826593,505817,684978,161860,767795,27621,546413,853631,685789,863185,165013,437364,140922,988120,177348,644524,632375,58281,117160,924306,862113,436091,899344,1207,622733,622292,22701,332507,464696,136101,793580,274798,767845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]