SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018810 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018810 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189700,578246,946635,477056,28402,48631,400610,1026441,555880,488937,352195,205537,782240,748991,416623,948752,567380,165768,369493,857307,690433,478158,668158,737081,206960,402538,517925,279344,362327,228007,829866,367761,622271,874215,363025,307090,682490,693480,476035,188726,576538,861768,585346,856326,363044,450146,999395,799060,936348,440887,909230,703749,817199,331676,851824,668292,755175,709835,1005383,275722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]