SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019430 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019430 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772505,451592,301016,619885,17430,364527,140058,626399,839181,959333,567672,198274,401878,975356,187106,611918,179582,289215,43383,49406,234992,211832,838269,209938,586616,492297,1005790,1008312,249395,1027207,58289,74032,574683,574005,563517,692973,854913,804160,381596,865400,615665,952639,535647,737545,799432,198458,6380,42310,378385,768157,496043,266233,227803,203196,422099,444139,922314,518823,138830,167807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]