SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042916 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042916 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483873,124879,1016241,254930,934960,858565,311533,202228,905509,358424,969974,9696,344881,600091,487485,417483,141777,903016,556428,944225,45241,490700,540822,422395,480681,882539,616630,162901,163980,356063,69923,950494,575142,705570,1020447,694361,320645,922859,44626,426556,992501,575852,571474,425108,205243,600304,734159,588824,682778,669061,207676,816959,43368,1001073,540421,14096,346345,18572,1040869,612456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]