SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033291 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033291 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793067,753836,118845,804255,978725,808724,1033375,476899,472611,883827,677423,704008,718367,785300,905042,879990,172812,94167,366776,231187,514711,200786,384151,686385,695346,419342,749409,659418,197773,378533,24264,396088,398719,18579,8436,530437,468447,919296,528739,769511,244224,232455,279443,185223,132258,113048,138765,158582,61256,389716,142473,827042,429974,926482,894724,492398,339744,1016097,6616,66605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.025673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001214s ]