SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002818s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 904925 LIMIT 1 [ RunTime:0.001519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 904925 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940759,808958,1016015,691737,559089,37398,331117,449756,352016,404596,819934,640267,443141,188648,788707,304285,22422,125473,383433,46936,978942,346504,804424,177826,915264,278663,40114,581802,695319,876096,435289,184507,85685,388899,803243,711226,103876,892269,742921,181789,568216,491509,735073,993339,748496,697337,478826,757895,89258,73336,139640,307581,1009961,455037,754688,277488,473258,910573,97540,3225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 904925 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 904925 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]