SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546948 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546948 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508433,399383,402973,83033,172401,372171,447489,875365,72223,316628,603679,965263,643798,731325,920791,157502,730244,215813,292753,252423,811789,848243,221944,91562,909646,920312,978032,281313,163574,260343,357018,786992,306473,36431,330078,852467,676013,201579,293895,189948,816804,570116,540362,504415,577881,235090,742422,902470,999381,425216,744887,162321,500954,38581,817797,711631,198791,410909,73170,434578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]