SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300181 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300181 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532865,165903,622762,570391,792766,751696,1035352,741540,447555,953870,414111,76178,1046613,96069,913146,947183,300397,665079,845085,675490,43513,417142,302820,333186,209385,247603,373737,243502,296360,1026011,841836,1020902,289054,1037973,1013354,511654,861272,477803,304776,32109,844649,107504,525228,823809,310414,421732,607792,618612,940843,125644,223156,695263,745344,680247,514822,684384,280590,112414,683054,875493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]