SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542611 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542611 [ RunTime:0.002889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023083,481871,683456,192058,24761,976157,986806,792993,333640,579951,569817,193750,742238,544649,356302,137139,54454,753561,536678,650972,319956,471572,72644,484089,1042671,875660,926901,97061,215972,210114,948486,1045146,403873,49223,1005978,627956,297530,1039187,486261,1023306,712038,113974,315770,36041,1030266,241220,932668,584189,453345,504008,438595,281961,267349,772210,238702,404964,222673,861449,401721,605318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000817s ]