SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038316 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038316 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120991,991986,707109,973753,229248,239060,969448,29563,298864,354172,331780,520215,494763,1014629,293058,451566,107802,703409,852879,545379,470689,141917,877946,447442,423580,810341,59161,681745,949469,769529,479875,474666,473825,127252,754883,576083,135733,641969,951016,400655,696279,328501,188955,420706,965353,1018458,586385,29801,411968,990175,725737,545609,739032,820676,302018,567469,611307,809187,1001624,249546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]