SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564839 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564839 [ RunTime:0.003909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717311,470582,448028,162466,150286,550968,663612,903375,318448,519156,26296,821431,448638,284021,969744,661260,99407,935984,535241,131595,193998,96136,984790,649583,589744,462897,617275,405480,78221,262925,1048584,833823,732463,235279,604938,143818,817552,701136,136004,601948,866608,51599,547204,338264,574550,525110,195197,912079,845491,539712,565444,806203,346523,220372,558917,219021,245003,463393,400174,1011653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003419s ]