SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 243612 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 243612 [ RunTime:0.002557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51958,114416,325916,502031,81307,683831,485708,432541,273737,931574,757304,255146,282812,84459,87630,547862,968806,129454,507646,718768,154396,195389,127971,100764,324716,248309,1010161,403109,665067,140539,742689,197976,784390,733088,309550,894180,214028,958766,31553,408467,1044044,794259,682736,679304,870367,495569,148210,1028126,137489,686838,435267,943351,642294,957185,1008504,174360,339333,359971,76276,162032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 243612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 243612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]