SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545220 LIMIT 1 [ RunTime:0.000603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545220 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886199,538435,405210,358180,71311,672694,70455,666215,60236,519285,301790,104411,717644,439063,1015862,1007008,343252,864028,318713,742906,629556,585215,302831,780306,685643,115286,216770,866597,220521,843084,786837,719191,707302,133278,1048844,236432,515260,681428,869189,1044411,800906,477085,681436,85212,383191,885978,989994,978304,866377,72071,1017375,353015,169810,184722,863002,833548,60293,528319,766557,391758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]