SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456937 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456937 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181140,178683,1008216,31334,841036,944777,1034586,226761,743953,200433,817950,132874,723481,427672,976137,499955,485622,690231,810368,489797,458561,398661,624548,634691,219059,897543,980495,915998,557272,61808,139215,461440,280110,696002,763602,849220,149665,859752,583604,643260,779531,66004,681921,238695,964444,630717,399274,955738,33608,868888,1044129,117767,432070,54575,35329,986094,985642,482394,780129,292407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456937 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456937 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]