SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420425 LIMIT 1 [ RunTime:0.004341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420425 [ RunTime:0.005478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221528,272849,1012135,553435,1045558,1006294,228631,841855,575781,46970,947032,132056,624041,82734,1014515,435920,95041,372294,274920,303418,702858,1046673,103109,437709,127788,758351,553974,550155,1001222,375371,1018719,76167,1042810,819891,949934,92299,844874,665917,889942,353913,518459,85378,225112,971016,421215,1004208,746664,957214,368234,194550,948780,159377,346049,529741,959486,93212,1002584,666583,807534,380645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]