SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311683 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311683 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812639,971152,257045,716660,438585,442181,398165,622800,67416,212131,939762,727209,71110,114905,811624,115523,974022,204305,18181,70835,549054,849073,966523,533943,722316,727405,481443,226100,304528,56187,674387,567015,124745,194913,145095,836424,669855,263245,475721,647433,296643,434196,665943,565752,1044713,492906,884004,277266,710261,518438,999709,792919,91719,228770,976966,598136,87063,730106,511577,552236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]