SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415104 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415104 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988927,10165,26074,547292,244642,1036775,181546,800010,369001,558145,416114,635296,474488,836579,549768,161542,552415,766180,305456,514430,888036,99320,575783,295327,306996,587894,865891,215202,918059,734469,404888,566666,49807,923013,282591,697521,113258,820413,621792,474171,218882,98503,831142,615490,792841,454269,295788,568551,990725,518463,145431,231177,219349,467616,756974,242245,36695,263346,730396,198921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]