SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346413 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346413 [ RunTime:0.004807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033873,452514,87561,872167,757344,744492,416288,36982,613604,293507,595726,756557,319699,966109,219668,285778,405095,517548,549885,287940,522830,373505,835191,685537,815517,694198,201245,415887,920030,820934,867740,176796,705776,195003,899891,354030,213744,615403,51026,572765,304884,680222,342143,12513,719393,748343,790844,827028,850752,296314,188711,225118,536975,397674,440271,793019,699575,845417,257786,750687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]