SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001516 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001516 [ RunTime:0.003627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527043,29911,541623,6533,584214,873515,52706,96135,1030625,226022,591675,351675,352861,222813,746548,306345,363754,24554,808439,1004853,226781,613920,819023,1035574,972881,23559,375323,409712,899803,865743,219427,38511,365864,35815,1013351,131649,710233,6827,914041,483128,165110,901014,670409,404189,617833,406537,638175,50186,615220,645927,993174,507097,488321,41867,158723,510572,655803,891103,435609,355521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]