SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354891 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354891 [ RunTime:0.002135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69715,460563,808339,644986,1015100,760475,797083,346771,855632,918141,128524,244816,477605,629246,327110,528294,40824,643119,316101,864320,630385,109159,611206,925807,525863,499294,968391,96331,768956,574703,639533,147031,241572,50586,172000,495618,1046439,616344,189493,890858,194223,273698,604070,535466,882123,633448,764745,229779,929858,485415,577884,759700,624380,244222,1042784,708789,547934,106542,534746,335567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]