SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41412 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41412 [ RunTime:0.002425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188641,455466,168156,163495,704557,760126,53405,687297,381022,81427,1002261,795184,690324,516687,284989,827927,313607,162043,704663,980171,838854,434394,971432,914336,64891,930011,471917,138157,1003871,134589,331775,938166,136337,839567,314411,784830,41239,304808,466748,473160,920006,514810,1023923,239551,21877,416485,349635,50409,528791,92030,541403,1003496,848195,393816,166007,485831,545758,246106,190699,14390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]