SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002493s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292638 LIMIT 1 [ RunTime:0.002941s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292638 [ RunTime:0.002490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987604,444065,242746,302986,134588,933891,595022,562914,528651,899496,265275,556565,728827,777107,844381,466274,416026,435683,872157,407200,406173,556019,933991,623388,842085,1034179,606706,286979,761911,130064,351705,828807,356496,554947,108357,391723,772222,41657,932208,706960,258445,1028438,140477,987098,520185,1041734,744275,359988,538343,65979,749960,146145,258964,221261,1024712,823991,1037759,1029589,352765,1045520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]