SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539856 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539856 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314641,130161,666439,452800,796348,846355,616125,32236,855010,205157,311775,883172,787028,857728,464520,900699,56436,471591,244425,848268,476456,545988,698215,135850,219471,627602,212578,240052,874368,141638,741862,8031,63906,700279,608019,121691,350597,443150,208249,238036,359506,771865,804176,850295,700916,565848,839117,648895,122453,254677,913716,39691,732218,109036,673909,682937,360473,10495,655704,299703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]