SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548308 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548308 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775103,388206,900109,462049,675451,286104,128260,371775,351213,719716,677053,22548,946889,684319,525104,648596,1007804,1018859,826031,898195,592264,21008,349334,943053,527993,414756,886708,325377,294519,768343,478734,368437,918184,754081,380669,109093,905337,424992,242867,891861,111441,890954,309328,587483,328697,794990,985111,988813,134425,556461,288962,313807,426085,62493,492955,844619,710250,305731,920049,592652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003894s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]