SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020331 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020331 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516212,500670,847083,229514,28541,369912,571631,458880,317853,1003246,473418,183221,930353,922446,310440,624753,1039416,144300,675289,469700,988705,976100,886230,890559,532024,649304,257894,889757,353277,917449,53496,547489,500106,657567,548727,348243,637669,576621,2035,470176,434754,824012,771772,1015799,72405,381935,611432,291530,615697,592855,228579,803647,246192,820499,618444,540775,585275,18626,899170,191847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]