SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34996 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34996 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739664,13140,896307,502308,1012666,907255,93692,76773,201256,463654,998487,308094,187350,161110,708709,248428,59197,1005485,981994,918706,806528,78858,1020875,537178,87469,805482,128701,459153,745112,15381,297834,297176,196051,965271,253102,237493,975224,139488,305017,955833,587518,949804,144494,67127,296744,185743,507399,132003,558726,48452,558826,269182,169631,47184,805119,570669,845703,422715,802453,591662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]