SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504529 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504529 [ RunTime:0.001421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666505,918046,689419,472517,1023745,495173,387074,723697,775516,1017796,1030212,577150,500859,343333,670126,694682,267605,910726,988225,440167,800645,101579,1008960,978719,529970,992632,114388,496991,624541,1043830,286107,881057,200384,666130,628802,518325,571929,631495,212741,922618,109673,865177,154082,926793,302722,433742,847777,373273,243543,286181,849227,922427,552169,659832,1009907,953649,692824,969306,513211,378362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]