SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340516 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340516 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280668,941056,701833,936299,266530,13932,883421,496616,829027,890838,127774,91539,473384,451500,320088,763367,1011099,872566,325393,396768,198775,754800,1032308,152926,74429,997720,577479,567875,136307,205463,853561,16118,639109,809759,559279,296430,269739,679523,316046,153860,794816,257108,299351,260119,814139,122792,1020818,970020,686669,656094,783914,595445,784441,157840,910659,481312,229261,171052,373628,963142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]