SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383064 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383064 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842096,913892,1042586,392008,758413,1030327,519298,406845,478346,820623,791883,631986,264995,818311,23754,224912,801183,604208,1032929,506092,565224,650268,893716,826074,486848,748580,786298,56480,557822,191717,1022224,780958,677739,906446,23397,553786,899784,663477,669562,933631,981977,285506,471371,694861,235619,914644,535975,296387,984814,534656,995038,978048,72859,955789,724286,470808,378359,999069,910750,201645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]