SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 694005 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 694005 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522576,486416,744069,54750,201450,1002280,704725,393967,1018065,116629,13736,975012,1034299,16646,569925,634151,666259,530449,369173,669160,676862,239816,197833,418130,313335,772928,656026,787585,287251,746480,422161,512793,253048,828455,405976,821576,1016837,629202,559622,682330,980318,234277,728990,524253,679553,230822,512432,122980,478123,870465,175709,611590,308603,356151,1046730,180740,132606,705171,662479,528534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 694005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 694005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]