SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 674208 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 674208 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021949,703311,87549,308632,205636,8381,553715,376689,142616,725226,1004551,1002257,238866,652058,851199,139848,499679,194807,638484,406621,1035953,183851,131017,207088,623917,615412,429261,762772,841201,100496,219209,63227,129087,386329,771533,742214,691303,838144,503743,100804,899196,229167,295393,139072,950168,431450,136939,1037383,664147,1032899,441114,477788,868904,878418,175520,1034218,949017,1002909,457288,401456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 674208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 674208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]