SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533460 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533460 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595004,266863,1023762,478704,495141,562232,344037,1040028,280711,859981,491006,4620,988903,591079,570296,635844,961043,958758,435074,504526,988987,702348,780841,414920,540299,121422,541178,45430,569990,355712,217280,525126,247129,624412,714970,866765,296886,799524,17442,291909,73656,1019070,191093,731218,837375,868909,740144,1003455,341710,799950,984272,805663,180710,320098,938728,679112,456909,855850,589704,618717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004197s ]