SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046888 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046888 [ RunTime:0.006387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039351,457377,184853,751102,547912,64432,205775,107212,24161,156730,344890,436094,945816,439776,801850,327994,687964,263786,6340,241608,133,79454,181188,169659,397032,680040,363447,967762,535811,928734,720304,964696,801680,769388,100008,527635,553981,265304,414625,190510,303354,443710,914697,666663,547904,673813,660260,1039177,373274,496721,214903,697720,100781,916632,96949,114365,532641,210762,496904,517010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002166s ]