SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456581 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456581 [ RunTime:0.001435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583596,601697,10794,903129,595407,763532,799297,7840,733193,399086,859584,64537,291224,400135,797833,851407,751280,889063,958453,131467,720763,904635,88947,155105,117817,119857,33817,789428,232546,287363,832124,878339,198079,141182,895018,773001,773128,379680,846888,994622,108790,183385,903002,43389,57622,92400,541786,558275,574746,991793,911149,878913,749365,972724,227061,363352,206899,358151,74055,271396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]