SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512651 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512651 [ RunTime:0.002067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852587,1044081,640581,322894,470,258308,627728,674143,861621,932890,777692,874716,535531,504943,106844,660041,303270,427555,124529,763800,411093,22489,939753,255047,1003026,233412,61204,915561,825305,504647,1021229,634754,627350,350103,6062,373251,947633,1010345,781762,308986,300082,923294,17398,1039513,640578,750494,101516,838236,56697,394034,427058,678970,296952,1000492,651030,681740,744879,338244,500341,550561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]