SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109827 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109827 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891291,304832,652520,70597,891896,395109,975409,497454,401113,600456,26295,510100,970340,260920,426319,492861,675675,441981,798056,89896,67409,645348,637413,794033,940390,1015860,428428,915653,464048,501639,270342,977992,880910,276158,983725,352564,228843,158849,388324,757496,436582,768742,908551,693072,451920,1009111,342837,439471,361253,92333,924396,357207,317043,705625,107492,920148,423805,133294,878284,1044236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109827 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109827 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]