SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974615 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974615 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317458,11077,186777,1319,963323,778566,30625,801768,674101,79650,105641,185507,173411,948221,612264,638015,1020876,627110,160708,467353,946997,1012400,188728,1040899,67523,288705,483787,587357,974367,279539,495425,6890,634180,759567,577812,891386,821672,585542,245477,714184,889167,935997,243664,445305,301966,754396,675283,374784,136879,400395,542341,596655,52925,1009360,221493,182080,201360,953822,995653,727779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]