SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522965 LIMIT 1 [ RunTime:0.001326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522965 [ RunTime:0.001955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358197,675486,137740,587181,742886,187976,330951,465842,524093,759929,462288,457788,630800,144719,337739,1019056,425755,870049,765130,104861,81320,952680,301849,786587,285014,633409,711508,230336,905018,922868,92961,680862,577208,87847,221171,409214,453207,848276,858203,134931,632474,743286,583849,6460,381206,517808,975032,373269,369875,99141,300640,92202,778464,413678,720293,330339,247571,778805,29527,675763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522965 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522965 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]