SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380423 LIMIT 1 [ RunTime:0.002380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380423 [ RunTime:0.008304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267215,401817,34978,596784,353027,81339,189221,996429,1004776,534594,312818,310885,587385,733757,315915,825266,499341,773729,116270,445213,593920,658298,486018,1040154,306004,356326,685015,658616,981142,362400,655507,802978,435701,340880,605869,841656,7939,376699,573386,624067,800900,873501,154160,844651,249456,852830,272741,878932,651178,495107,961961,49400,777700,863691,134400,419954,933592,219801,765597,137445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001838s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]