SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 337591 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 337591 [ RunTime:0.003316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142675,981630,56862,350750,911554,726933,585293,1004761,91398,910512,915003,221097,671048,58670,110219,338254,326415,924594,956648,580412,811291,80702,677429,1021965,342652,240745,526365,759027,402014,91613,494844,713417,933018,843001,818598,414979,209696,808710,434255,858774,337655,885921,347744,914648,191193,792351,43160,199563,850285,481124,215019,779127,399660,275598,3968,301273,959864,868628,951714,739004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 337591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 337591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001191s ]