SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302601 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302601 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611153,941543,478582,671684,87314,592857,148826,697350,835700,226527,514204,829159,428480,726073,889918,88549,786188,294812,828211,1028640,354484,990198,680060,763901,492158,374104,315225,435577,341988,698647,342203,148026,934173,383974,274640,355656,84947,637465,775781,777817,40077,122779,678851,207520,937076,1016322,404450,380418,587262,271500,317282,650973,462686,1016941,718498,720034,896025,1006816,750958,434231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001811s ]