SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539853 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539853 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847652,243647,779423,376918,124801,939170,87968,224391,384227,200374,1047317,374586,1033142,47836,353455,186585,647916,559177,643824,443577,324659,611898,344449,611713,794752,890217,33188,251718,146973,855679,627558,791949,318061,340262,1021251,308382,378287,652185,836571,390165,824934,480707,576033,669687,877214,920621,746770,3153,267626,401854,568789,913477,538146,42445,328743,833806,186891,433732,67198,355845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]