SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037881 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037881 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998268,40963,958177,640114,793361,146473,584410,542657,832969,947635,684068,74984,689026,791671,158122,297508,832828,722971,262486,987290,793897,602936,303794,108601,122361,701147,540586,315487,232248,802783,633513,980378,595317,649003,873636,55633,417644,885970,1043114,525380,279006,500735,545198,829535,231684,932451,1017338,322717,534750,1047314,304882,730571,924748,124323,395350,841837,645,878352,239337,243590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]