SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038018 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038018 [ RunTime:0.002876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330066,197885,486903,41039,129143,821591,308337,558875,144910,447514,683086,512823,582362,285751,173855,39284,261583,172304,204517,54659,111725,712834,347382,967167,874618,627015,206023,741507,451313,172532,460760,874957,946683,660696,77345,661320,44853,115029,136971,862200,813050,762406,563338,793668,107381,466387,237980,192952,249715,713684,732163,496892,92398,566850,794928,955730,625361,586090,239848,171785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]