SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33580 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33580 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457505,625333,808454,825774,580642,344715,175916,975350,772110,787063,888193,270359,217964,345295,342736,233323,460897,986116,577392,675621,198973,132987,214757,662142,501941,1020532,85762,265738,1017199,438392,10017,355326,226871,37079,894885,209619,616550,384412,774008,944213,355717,909180,565698,335120,666723,652639,421678,1014986,1021972,283543,912059,580496,964591,282008,285626,394017,313814,245787,591422,329843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]