SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483671 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483671 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810169,690660,8618,955648,7807,96902,338929,904580,461267,737296,529593,214643,226005,1021527,204720,156104,13303,648780,527364,170495,79700,178591,307060,737740,886076,595778,688239,852563,343983,415812,56716,903674,62337,854535,976615,783016,288460,198055,1030546,657317,154831,695186,603643,331868,135588,812110,532679,88636,850567,898145,675879,986008,1043130,456139,77987,834405,382753,256203,779523,907023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005401s ]