SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403843 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403843 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295561,697955,821176,861509,1000123,87152,962712,394764,93472,962889,1044912,105270,593537,14164,85992,585233,981230,209005,227921,763138,183334,720625,824256,1040707,430302,135565,891504,617007,797482,353942,114498,641969,793898,581654,166522,472263,405188,961212,839417,220068,876884,100091,629455,595388,214603,343116,314162,821839,1008370,228041,962319,749058,671601,321308,902649,371167,528486,879033,888409,567770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]