SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.012506s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528710 LIMIT 1 [ RunTime:0.011261s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528710 [ RunTime:0.013555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036042,723477,303042,602645,839234,714955,505444,908063,738258,578169,332535,344317,851602,961406,222045,299918,145191,577223,359852,442152,1010864,373833,844483,875685,969320,851494,491292,788769,190885,91636,429052,355984,909945,171143,92628,529893,777698,353595,948272,513721,41102,920164,563478,455139,954543,1030895,184733,234461,465759,556176,290688,122382,1007331,74093,445391,257345,741819,711454,563854,796352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]