SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578308 LIMIT 1 [ RunTime:0.000924s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578308 [ RunTime:0.002549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995386,19315,376063,202485,520504,957826,225339,551088,230941,61508,443041,530680,816083,622712,719979,645879,994486,1041532,490000,191463,1002424,521621,427664,747458,449011,292209,450106,532644,236135,1027798,786744,576134,560326,983610,59348,754713,978154,240539,372290,424670,944730,919689,605708,87896,990552,598648,651284,326742,416505,388315,902857,534729,419365,980997,811386,492183,373293,586023,337671,972508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]