SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610738 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610738 [ RunTime:0.003240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449049,48018,481394,953483,196848,361566,376606,231433,123022,375139,148761,542168,838238,661255,734736,243958,506404,181103,957421,349092,75153,297249,917478,409309,134956,355519,853652,235280,752829,28132,7336,311054,1046370,326640,81855,372772,941362,24058,411892,12213,749331,75315,362491,1009475,300100,73847,592095,300071,217965,659651,871511,461091,947664,529121,304088,252942,607711,332282,514237,335499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]