SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001679s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501505 LIMIT 1 [ RunTime:0.000861s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501505 [ RunTime:0.001147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131240,35230,888921,643053,816732,505010,483807,183497,413209,821732,390104,247046,232975,208156,990229,394387,736346,599783,850549,245166,314796,816632,936595,73552,922304,411311,333780,574718,980950,596846,649536,678517,934151,757564,814927,452621,321175,182553,201923,548961,677812,17975,23969,1016382,348227,344301,58743,574878,441646,674729,82002,795652,314688,665184,964457,735901,372020,410882,272834,28173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003624s ]