SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315075 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315075 [ RunTime:0.002626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379959,462470,660871,29156,427814,1018813,697131,44475,547511,402946,778345,1010988,568752,43626,1023790,1031581,289110,150358,247374,6145,391186,123000,328859,496316,2608,382525,174571,194808,822710,479357,695334,293350,775019,17981,723997,977987,106844,521371,719479,1013161,983247,76315,533379,536301,557584,1040923,786488,383002,337855,696238,540925,823048,997770,294281,243012,586620,475969,542126,996316,343025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]