SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311240 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311240 [ RunTime:0.002044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202900,284408,418282,806851,743978,325433,157893,207170,457480,641684,348851,56243,885605,553447,289809,308338,938328,1013324,826876,869252,914670,990149,63278,941676,504997,141816,458083,113824,275275,444054,574298,954047,236709,977747,885,544719,743008,379655,968687,53740,803446,696377,383072,834215,662996,652991,929568,952025,465666,258543,1003141,138086,685239,852014,418314,740560,694324,796624,1045510,801270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]