SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417808 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417808 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719402,115919,701102,581442,101630,239,69604,314420,1022617,300810,244249,740367,176079,54588,467665,936845,647611,226042,157377,398581,995931,1020623,223438,200236,86198,247011,389627,662687,416714,887194,933361,948855,778541,727197,597342,120440,434008,316830,810128,884926,665230,83830,580042,112278,262846,927853,621924,482598,197704,770109,408879,319882,1031392,664380,506473,267809,378513,177722,667217,196140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000763s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]