SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108541 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108541 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562011,249794,704785,837960,135077,757730,189602,705829,202949,406892,363179,990470,209556,414474,460069,6531,372313,283164,680219,717014,1034938,391944,963006,401882,284045,587282,1037776,656418,870540,100980,136926,364573,1024950,794180,193681,954742,612513,131810,68941,849028,200836,818181,55408,670876,45100,327092,839919,378816,461807,963624,363852,140627,397639,122228,942216,455487,415131,433845,304611,471837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001766s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]