SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 115730 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 115730 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283819,7629,914958,864207,367194,27507,656858,591285,929983,77747,981370,631861,446589,389244,1019648,227554,205079,471514,841514,507044,460924,59672,998384,281389,548070,460559,675808,983905,715881,639968,317517,680925,246135,280406,431160,671198,245686,109238,46439,1010908,812870,426780,269304,616055,14234,551588,321783,833257,873750,502818,352216,973572,3069,856345,363867,865254,259951,897238,146572,384583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 115730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 115730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]