SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4817 LIMIT 1 [ RunTime:0.005008s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4817 [ RunTime:0.004488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270034,514579,394083,832639,284308,677308,745992,161601,210200,400813,176773,71679,804281,627748,728900,546105,377234,748604,748515,550333,872808,619162,559359,716975,841325,294664,237796,930321,480941,794244,547912,224744,938009,60705,1014373,794578,286165,1033125,59870,452095,359526,382096,555438,456194,367625,577619,30539,558064,18800,738135,378367,930615,757090,895935,361149,747582,663823,954992,84226,761836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001570s ]