SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802611 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802611 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621997,818672,943498,440234,167616,758579,197761,545914,106037,660920,579553,319010,1014777,160522,647961,965848,329490,225305,129304,642712,781104,450922,202598,513270,59749,1028914,592600,671612,994080,459219,1036171,543668,1028998,962712,826262,914794,132953,318973,280843,945323,939037,167995,63642,470911,641597,621914,503800,788783,428736,225762,949333,7939,513312,675447,889790,228808,968565,593199,626733,46576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001426s ]