SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103661 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103661 [ RunTime:0.002405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575296,623118,41331,135783,1029452,170188,656994,412804,914039,408757,510729,380580,250733,576578,933587,552405,890213,2811,791404,123083,79601,476015,67688,879950,753593,406979,623101,400512,904267,62034,1003256,700612,490419,437839,625239,665263,678989,360926,856306,255309,103168,104564,891911,684119,377089,170905,914387,70298,428384,96785,873439,250748,316628,126922,770110,335603,349871,582271,895156,100201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]