SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529559 LIMIT 1 [ RunTime:0.002499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529559 [ RunTime:0.002716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001976,66518,775836,1011225,919966,616140,792602,394345,302389,252508,351322,223124,245016,43180,985419,430868,735645,289621,413275,1000524,515113,166560,482401,170005,805407,556704,705291,581902,398852,883843,75821,697387,544720,536192,715751,211377,991439,226368,620494,193530,224113,889265,213809,544727,610426,897650,392361,877754,628845,427044,93568,126103,1038890,474476,872037,517778,811835,718667,751786,577734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529559 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529559 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]