SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323570 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323570 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967074,305750,253398,7527,25581,251120,713026,647887,895492,434490,968786,504140,728122,200453,961035,881356,106758,350303,761543,936785,538698,612154,511593,892528,213107,268677,210687,271421,1045597,408016,28580,558734,466276,414169,414717,37745,464960,59277,111214,624316,264984,663714,931331,247093,553122,722743,563264,926391,676831,787601,1038987,767423,1026,50590,159141,615122,920096,478058,1031344,812085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]