SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530718 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530718 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731588,592165,525407,494527,406030,182043,550792,672626,130128,755429,511524,507358,183169,413506,342008,117844,171832,135040,78553,963806,836722,453844,484822,577327,895251,109208,45779,296081,441458,684538,961186,276626,232749,982250,688326,549198,965017,309131,14631,192473,683472,199147,385919,600667,96889,986147,560070,103175,921042,450292,538103,39761,557493,430437,591619,805525,974613,230770,896307,256536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]