SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002563s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40161 LIMIT 1 [ RunTime:0.003035s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40161 [ RunTime:0.004753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176235,861484,474129,394854,352479,252668,629025,639126,272452,443266,135975,860817,110648,889541,1044512,370353,46540,514237,71034,591892,1012264,550512,138477,762745,356835,405551,163405,400037,1025634,168687,493773,151881,860233,1016034,828784,974235,198688,626146,549222,417025,210528,1009124,859276,785264,455760,261239,775460,295132,387632,259735,689384,586461,1046098,661905,884202,948804,631333,169670,461179,782409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000872s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000726s ]