SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419412 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419412 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23615,561179,1034094,857321,236265,49957,166425,891228,1041150,342121,764085,321499,789874,566006,660204,191676,720149,349102,825215,207236,398871,199294,75343,1003709,553359,262401,756391,813587,626859,439800,59991,397155,1242,13315,773704,151167,482911,630726,107576,105100,665581,464529,637071,697491,869505,774701,460056,25809,604308,711010,681863,890013,107103,654350,66219,127265,289566,73166,576358,394674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]